Run a Crosstab

A crosstab, or cross-tabulation, is a table that depicts the number of times each of the possible variable combinations occurred in the sample data. The results display a table and graph. This feature is available for both PDAS and RDAS.

NOTE: For more information on analyzing crosstabs, refer to the Analysis Methodology section.

To run a crosstab report, perform the following:

  1. Click the Crosstab tab. If you added any favorites in the Variables pane, those display at the top of the pane.
  2. Search for the appropriate variable and click it to see the available options:
Option Description
Add to Favorites Star See the Add to Favorites section.
Set Row
  • Click to add the variable as the Row Variable to the Crosstab Creator on the right.
  • This variable will display as the horizontal row in the crosstab chart and in the X axis on the graph after it is run.
  • This is a required field.
  • If needed, a crosstab chart can be run with only this field populated.
  • Only one row can be selected, so the Row button will be disabled for all variables so another cannot be selected.
Set Column
  • Click to add the variable as the Column Variable to the Crosstab Creator on the right.
  • This variable will display as a column variable in the crosstab chart and in the Y axis on the graph after it is run.
  • Only one column can be selected, so the Column button will be disabled for all variables so another cannot be selected.
Set Control
  • Click to add the variable as the Control Variable to the Crosstab Creator on the right.
  • This variable will display as a control variable in the crosstab chart after it is run, which will display a different table for each. For example, if the Control is “Gender”, then the results will display one chart/graph for male, one for female, and one for a total.
  • Only one control can be selected, so the Control button will be disabled for all variables so another cannot be selected.
  1. Click the Set Row button for the appropriate variable.
  2. Click the Set Column button for the appropriate variable.
  3. Click the Set Control button for the appropriate variable.

NOTE: As you select variables, the Crosstab Creator builds the table in the Crosstab Results section so you can view the table before running the crosstab and populating the table.

  1. If you change your mind on any of the variables, you can:
  2. If you are unsure about which variable to select, click the arrow () in the Variables pane to view additional information about the variable in a side bar.
  3. Select the Weight Variable from the drop-down. The weight will make the crosstab results representative of a target population.
  4. Click Run Crosstab. The charts and graphs display with the rows and columns selected, with each chart a cross-section of the control selected. The source of the data displays at the bottom of the results.
  5. The chart and graph can be modified on-the-fly using the checkboxes. Those include:
    1. Crosstab Table(s) – Selected by default. Displays a crosstab table in the Crosstab Results section.
    2. Chi-Square Test – Selected by default. Displays a chi-square test table in the Crosstab Results section.
    3. Chart(s) – Selected by default. Displays a chart/graph in the Crosstab Results section.
    4. Unweighted Count – Adds an extra row for the Unweighted Count. The number of respondents in the cell.
    5. Total % – Selected by default. Weighted count in the cell divided by weighted count in the table.
    6. Row % – Adds extra rows for Row %, Row % SE (if the “Standard Errors” checkbox is selected), and Row % CI (if the “Confidence Intervals” checkbox is selected). Weighted count in the cell divided by weighted count in the row.
    7. Column % – Adds extra rows for Column %, Column % SE (if the “Standard Errors” checkbox is selected), and Column % CI (if the “Confidence Intervals” checkbox is selected). Weighted count in the cell divided by weighted count in the column.
    8. Confidence Intervals – Adds an extra row for Total/Row/Column Confidence Interval (CI), depending on the other checkboxes selected. 95% confidence interval for every estimate in the cell. Confidence intervals for percentages are constructed on the logit scale. This produces asymmetric intervals that are more accurate near 0% or 100% than symmetric intervals.
    9. Standard Errors – Selected by default. Adds an extra row for Total/Row/Column Standard Errors (SE), depending on the other checkboxes selected. Standard error for every estimate in the cell.
  6. Hover over the graph to display the weighted counts of the variables selected.

NOTE: The graph displays the weighted count, no matter which checkboxes are checked.

  1. Hover over a box in the legend to only view the elements on the graph related to that option. In the example below, notice that the bars related to "95" are highlighted and the other bars are grayed out.
  2. Below the graph, you can modify the graph by selecting the different Value Options, such as percent or count, and View Options, such as viewing by major group or hiding elements.

See Also:
Export a Crosstab CSV
Export a Crosstab PNG
Access Recent Analyses
Recode Variables